from ironxl import * # Load the Excel workbook workbook = WorkBook.Load("sample.xls") worksheet = workbook.WorkSheets[0] # Get range from worksheet selected_range = worksheet["A2:A8"] # Get column from worksheet column_a = worksheet.GetColumn(0) # Get row from worksheet row_1 = worksheet.GetRow(0) # Iterate over the range for cell in selected_range: print(f"{cell.Value}")

Select Excel Range

IronXL for Python makes it easy to select and work with ranges in any Excel WorkSheet. The code below demonstrates how ranges, rows, and columns can be selected. After selection, aggregate methods such as SortAscending(), SortDescending(), Sum(), Max(), Min(), and Average() can be applied to the collected data. Note that when methods modify or move cell values, the affected range, row, or column will reflect those changes accordingly.

Range

To select a range from A2 to A8, use range_ = worksheet["A2:A8"].

Row

To select row 1, use worksheet.GetRow(0). Indexing is zero-based. The range of cells returned is determined by the union of all populated cells across all rows, including row 1 itself.

Column

To select column A, use worksheet.GetColumn(0) or assign the range address as worksheet["A:A"]. The range of cells is determined by the union of all populated cells across all columns, including column A itself.